2016-02-01 - 24561 - Service Request - BPP Performance is slow #BWProductionIssues
24561 - BPP Performance is slow
Service Request
Requirement Summary
As BPP Performance is slow, so we are making some changes and taking the necessary actions and need to point all necessary reports in the global folders to the BPP Logon Group.
Admin Info
Purpose
|
As BPP Performance is slow so we are making some changes and taking the necessary actions and need to point all necessary reports in the global folders to the BPP Logon Group.
|
Requested by
|
Mark Harris
|
Issue Date
|
02-01-2016
|
Resolved by
|
Uday Kumar P, Naveen, Dhananjay and Venkat.
|
Resolved Date
|
02-02-2016
|
Document Status
|
WIP
|
Detailed Problem Description
As BPP Performance is slow, so we are making some changes and taking the necessary actions and need to point all necessary reports in the global folders to the BPP Logon Group.
Prior Tickets
24561.100
24561.200
24561.300
24561.400
Solution Analysis and Recommendations
As all crystal reports pointed to BW server are running on single server causing the BPP Performance to be low, need to change the database configuration to server group for all crystal reports and need to reschedule them.
Please find attached list of reports for Global folder(81), North America folder(10) and Emerging Latin America folder(13) in BI Production:
Emer Latin America BPP Reports.xlsx
Global BPP reports Scheduling.xlsx
North America BPP Reports.xlsx
Resolution
1. Need to change the database configuration for all crystal reports pointed to BW Server into BPP Server group.
2. Need to reschedule the reports after change of database configuration.
3. Need to recheck scheduling options after successful scheduling.